

USE [RD_COMMON]
GO
truncate table AR_Star_Customer
go
truncate table Sales_Star_Customer
go


/****** Object:  Index [IX_Sales_Star_CompanyNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_CompanyNumber')
DROP INDEX [IX_Sales_Star_CompanyNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_Customer_CustomerNumberID')
DROP INDEX [IX_Sales_Star_Customer_CustomerNumberID] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_Customer_ShipToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_Customer_ShipToNumber')
DROP INDEX [IX_Sales_Star_Customer_ShipToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_InvoiceToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_InvoiceToNumber')
DROP INDEX [IX_Sales_Star_InvoiceToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_ParentNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_ParentNumber')
DROP INDEX [IX_Sales_Star_ParentNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_ShipToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_ShipToNumber')
DROP INDEX [IX_Sales_Star_ShipToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_Sales_Star_SoldToNumber]    Script Date: 10/03/2011 15:47:39 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'IX_Sales_Star_SoldToNumber')
DROP INDEX [IX_Sales_Star_SoldToNumber] ON [dbo].[Sales_Star_Customer] WITH ( ONLINE = OFF )
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Sales_Star_Customer]') AND name = N'PK_Sales_Star_Customer')
ALTER TABLE [dbo].[Sales_Star_Customer] DROP CONSTRAINT [PK_Sales_Star_Customer]
GO


USE [RD_COMMON]
GO

/****** Object:  Index [IX_AR_Star_BillToNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_BillToNumber')
DROP INDEX [IX_AR_Star_BillToNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_Customer_BillTo_Company]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_Customer_BillTo_Company')
DROP INDEX [IX_AR_Star_Customer_BillTo_Company] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_Customer_CustomerNumberID]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_Customer_CustomerNumberID')
DROP INDEX [IX_AR_Star_Customer_CustomerNumberID] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_CustomerNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_CustomerNumber')
DROP INDEX [IX_AR_Star_CustomerNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

/****** Object:  Index [IX_AR_Star_ParentNumber]    Script Date: 10/03/2011 16:01:47 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'IX_AR_Star_ParentNumber')
DROP INDEX [IX_AR_Star_ParentNumber] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[AR_Star_Customer]') AND name = N'PK_AR_Star_Customer')
DROP INDEX [PK_AR_Star_Customer] ON [dbo].[AR_Star_Customer] WITH ( ONLINE = OFF )
GO

